﻿using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ExcelImport
{
    public class ContextFactory
    {


        public static MySqlConnection CreateSQLConn(string connFile = null)
        {
            string MySQLConnectionString = string.Empty;
            MySQLConnectionString = ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ToString();
            var connection = new MySqlConnection(MySQLConnectionString);
            return connection;
        }


    }
}
